UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0R75bY40gqVBkPfkXiFk6M2rcv9VwH4t3PXwPcgkW4Q='
WHERE
key_id = 'bf568c2839ddd85f36201bd87d5e22080aae52e10ebf1063c5b3a9503ef17d79'
AND (
token = '0R75bY40gqVBkPfkXiFk6M2rcv9VwH4t3PXwPcgkW4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)