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