UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fPVC+sKhCp/oMp17obhJti5IJ7U08y2i0fStjHq1XmU='
WHERE
key_id = 'b5a02dc4fb11f21c2a54b4b4eff3a01d9ee6d045276b606441c37a183d56c42f'
AND (
token = 'fPVC+sKhCp/oMp17obhJti5IJ7U08y2i0fStjHq1XmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)