UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qcj7NlUmtIrbMdl151gPnQgiriCtNmpM58qyu7agWlk='
WHERE
key_id = '0c34a2760fbca71fc565daf7c0bcee8003d4d5c053310390e8d490c3fafa4b07'
AND (
token = 'Qcj7NlUmtIrbMdl151gPnQgiriCtNmpM58qyu7agWlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)