UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZT7XNftnt+0TbaDYlpgv1apsnGrm8jHBEEGxRYkPZE='
WHERE
key_id = 'ffe4e2144d998fe8cfb47b67bc00b011ba66e57143c817adcc3745edbe48e693'
AND (
token = 'CZT7XNftnt+0TbaDYlpgv1apsnGrm8jHBEEGxRYkPZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)