UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn3gG9y0CpykBUjhTFkVcmUS27pPi1ZtQ7HlW+jAZLU='
WHERE
key_id = 'a9ac4686d67a5bbba6720ac1bad61f40c37dd1965a32461b854ab82e221dcfb3'
AND (
token = 'pn3gG9y0CpykBUjhTFkVcmUS27pPi1ZtQ7HlW+jAZLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)