UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCl41H+FIpOgfMkUKE4gIk0js6Xhao/BWfA7dHrkl8A='
WHERE
key_id = '8ff050d72f8f0b1d3a78c6caeaa8a0c6812e4c3460bd3aefd477886095675539'
AND (
token = 'bCl41H+FIpOgfMkUKE4gIk0js6Xhao/BWfA7dHrkl8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)