UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZpR+J1n4amInGVvY4L+ifk6e7abgAgXVKAP7D0P5rE='
WHERE
key_id = 'a2f3be581948f03d2f476e26aab434ad70c1158316915a39f22140a52a210181'
AND (
token = 'oZpR+J1n4amInGVvY4L+ifk6e7abgAgXVKAP7D0P5rE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)