UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kznESNM8xpn4AQNkxfO6865Bhni432eTjJ3Q8lOVQIs='
WHERE
key_id = 'b3708a931e73bc40327a2247ee43761e9e7e598de18c0f40f7ca453e1113eef9'
AND (
token = 'kznESNM8xpn4AQNkxfO6865Bhni432eTjJ3Q8lOVQIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)