UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0jys0gsnvo9+Ld2XQmjHBAwEAMF1/rGMvS1jITRjRmI='
WHERE
key_id = '9306a86fff5f39d99ac3933b8914fa18171f9af806afd34bae0f9a245641ae96'
AND (
token = '0jys0gsnvo9+Ld2XQmjHBAwEAMF1/rGMvS1jITRjRmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)