UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhoXm4yCdcbf3gz8hPa8sGdQo/BNDDZG/l9c2hfduNU='
WHERE
key_id = 'ef9a0cd38beb3863cd100b69cdce3ad51d459cb5ed05baa01062aabfec8cb13e'
AND (
token = 'nhoXm4yCdcbf3gz8hPa8sGdQo/BNDDZG/l9c2hfduNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)