UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NSo3wRZEuGC/0YNDIj0FOgwSYnn3hXahG0K2wU6ezfw='
WHERE
key_id = '2a2d4f6facf52eb806612a82c249dbab474953ce89fcdb041a5c2b09815df565'
AND (
token = 'NSo3wRZEuGC/0YNDIj0FOgwSYnn3hXahG0K2wU6ezfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)