UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pE85fWzL4cMCAi4iJW96uJ/UZHjCfVdNwKCGJI1USfY='
WHERE
key_id = '7adf06d8affca6c928a5f858213e7660558cfd741a5b3f0645b72ae1213bd43b'
AND (
token = 'pE85fWzL4cMCAi4iJW96uJ/UZHjCfVdNwKCGJI1USfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)