UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zo4kpmz9IRQ4NNR7JSg2rz9Xv92hcXy07wZmGppiNWs='
WHERE
key_id = 'f2a7fa6ae191f83cbdeb0ed1419d3f7128e06583a47d5776603701f21a9acdd2'
AND (
token = 'zo4kpmz9IRQ4NNR7JSg2rz9Xv92hcXy07wZmGppiNWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)