UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCMG0aONNdvZg55VFhbnYUunfivEafZEafOtnuO+DLs='
WHERE
key_id = '648e93ef141f62c2ec7b0e0cf841c723b349a491b80bd8fb061821c343642b1e'
AND (
token = 'SCMG0aONNdvZg55VFhbnYUunfivEafZEafOtnuO+DLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)