UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxR8JHYcgCCukR+N6kEM8U1Si9jrHkKlRXxyL+UbVMA='
WHERE
key_id = 'c22ff305b9e7c92b0b32b27e3897dc67f5d131f64244cd9548be11b8574cde3d'
AND (
token = 'gxR8JHYcgCCukR+N6kEM8U1Si9jrHkKlRXxyL+UbVMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)