UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6yavOmFuHMCnMOXlmSDIEn+wLbxJAyLSkDfKvRdhDkU='
WHERE
key_id = '8f7e36b498c1456b78ad79048a56f4c3c36993a897e14e7d2441b92a4f0f7de7'
AND (
token = '6yavOmFuHMCnMOXlmSDIEn+wLbxJAyLSkDfKvRdhDkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)