UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M7/T7W1oRCQtNgXZLxvgtLOWdjs4GOETpDEQlmGXgmo='
WHERE
key_id = '179e7da508b15b4671951bed93b26371c962ace83219f2206f9f235a9dd3a20e'
AND (
token = 'M7/T7W1oRCQtNgXZLxvgtLOWdjs4GOETpDEQlmGXgmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)