UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XV7uK0frr0sknS+j68/9soHGGD3L8br0Q6XtvIfxul4='
WHERE
key_id = '50b6b84df19d7100f0e0c672ddebdd2b0919de597e7cd6e3448bbdf7da2caf3b'
AND (
token = 'XV7uK0frr0sknS+j68/9soHGGD3L8br0Q6XtvIfxul4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)