UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80sCUgBRq8FIgOjV4flG3H4ukv7hmJjLFX99mSux5d4='
WHERE
key_id = '5a6c4f75d5c73434b7c0d569300b09766cfa9c1f1ecb1d552c45c5d68817b37a'
AND (
token = '80sCUgBRq8FIgOjV4flG3H4ukv7hmJjLFX99mSux5d4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)