UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZoQvwdpGjLjFp9wesdLdxJxMLQ2v5iQaji+w6M6z5JQ='
WHERE
key_id = 'a509174107452d73cc1f7c6d094453833769a4a1180674b6052fb0f0700d1413'
AND (
token = 'ZoQvwdpGjLjFp9wesdLdxJxMLQ2v5iQaji+w6M6z5JQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)