UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJqYxRegdTkf33rUqngiCC4MR8XseDWUDQSWkvTcL8U='
WHERE
key_id = '47a9c0280bcb9a1c6f7432a3c7a7ae680f0bb513acfda2ce24fbd8fbd9603929'
AND (
token = 'zJqYxRegdTkf33rUqngiCC4MR8XseDWUDQSWkvTcL8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)