UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lhbu2hAY52lPecZxRW+4vmCHUSPvzc2bSDhum5XNAVA='
WHERE
key_id = 'd2eb0ab473bb69823719c9a59802914966dcfb2af59caa7aff43f59ad4bd1604'
AND (
token = 'Lhbu2hAY52lPecZxRW+4vmCHUSPvzc2bSDhum5XNAVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)