UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WEgRAew2omAw3H0kiD4AVudBzvL6B7/6WzgtNl2pSKM='
WHERE
key_id = 'b7a92d5147c8b26898727bfea2098fcc10317c2112d7c49bc25a6980ee5e66fe'
AND (
token = 'WEgRAew2omAw3H0kiD4AVudBzvL6B7/6WzgtNl2pSKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)