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