UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/pCmgmTNrRROA1rA11bdKUFnRdWw0OuQmOCqQzmbaLo='
WHERE
key_id = '5ca2eaca146040585291ff0aa9094231654cb4d99d5fc3dc383644d7439d026a'
AND (
token = '/pCmgmTNrRROA1rA11bdKUFnRdWw0OuQmOCqQzmbaLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)