UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DkGAxE9lzBXWL/7SH+7l2inLv+4YIZeMMu7JFP93r2k='
WHERE
key_id = 'c0d5746100a46b465be2c9dc563576ed166b505079a340b96df04475f53373a1'
AND (
token = 'DkGAxE9lzBXWL/7SH+7l2inLv+4YIZeMMu7JFP93r2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)