UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dBItSOCzXMSflrs1o/TFw1oBjCw8EJjMt2T+AfWjgg='
WHERE
key_id = '7c9b7731dd07700601236b5bf798031f160a865a1890f2c9f1db3bb2a4727047'
AND (
token = '7dBItSOCzXMSflrs1o/TFw1oBjCw8EJjMt2T+AfWjgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)