UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AEjjuocfvngviw/IpV546M4xWLWe7reqsUTpQLZkwkk='
WHERE
key_id = 'd4866579c02aa0e4145f0d8edb8055c7008bcce5386c38f66420cdb03f32e332'
AND (
token = 'AEjjuocfvngviw/IpV546M4xWLWe7reqsUTpQLZkwkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)