UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1C0JBJsO8ivHBdRCxfp1GBgdKCPfvgM8AGNTKFgP42U='
WHERE
key_id = 'fb4e08c27400dcfb3e4afe3812f2ca112ae5c110257ef518f90549bfbde721d9'
AND (
token = '1C0JBJsO8ivHBdRCxfp1GBgdKCPfvgM8AGNTKFgP42U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)