UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iOXKwU71uQBvAVM3T6EUhL1vb9XyQrSHuBFGt1p8cCc='
WHERE
key_id = '8a8b2e71fc7e66d54ba2afc6c1cabcb6ad94fb65ee2ceadc7d14ed73039aa9d4'
AND (
token = 'iOXKwU71uQBvAVM3T6EUhL1vb9XyQrSHuBFGt1p8cCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)