UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SdEhUYW9YPiBh9FkpMeZYBgVav0vIRS9M8nj7v0ncUo='
WHERE
key_id = '457fd8bbe156418a80f1bc0be59fb66439140e8650e6b7df1f68c3d4c07cab03'
AND (
token = 'SdEhUYW9YPiBh9FkpMeZYBgVav0vIRS9M8nj7v0ncUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)