UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CP3QRlahGQlqrjzVuVyUFT7uOirec2aJUfMSluV0+Xs='
WHERE
key_id = 'a299317d752d99a9f55cd996df426cca509e0c981c76f022932eb6ef5e2e0f5e'
AND (
token = 'CP3QRlahGQlqrjzVuVyUFT7uOirec2aJUfMSluV0+Xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)