UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mVb9d4Yiz7bh2Fh+1uNZRpB3RvodaBhYTLuJ+vQId0w='
WHERE
key_id = 'e6aadb7daf4fdf29b669f970edbe3f4b7e8388f0e917f0c904a24437817e2cd3'
AND (
token = 'mVb9d4Yiz7bh2Fh+1uNZRpB3RvodaBhYTLuJ+vQId0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)