UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AWDmAvWuRvXpoS0s7U5V9g188tE6r6PTc3S2p+fFxBk='
WHERE
key_id = 'd9ef611f76b4baa361e8b687f07401d46a938fee283b861f31bee3d9f8795ee4'
AND (
token = 'AWDmAvWuRvXpoS0s7U5V9g188tE6r6PTc3S2p+fFxBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)