UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DP6NlfjXiKIN/LRSr87acg4ehmDz18NziEmPf5QnkIY='
WHERE
key_id = 'e6ec932cea728f4bb19370640e5985015d33ea84d290484d7d8f8c8c4db9d687'
AND (
token = 'DP6NlfjXiKIN/LRSr87acg4ehmDz18NziEmPf5QnkIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)