UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XGg8vIycbv2wbhTEKy4tc1Vbc1du76UQOQ8LJWlMl8='
WHERE
key_id = '659aa304d5dc47607cfd66e8f5f0dae4864ee4ab73131814d3a0a20d6bafb2a0'
AND (
token = '7XGg8vIycbv2wbhTEKy4tc1Vbc1du76UQOQ8LJWlMl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)