UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4AX7iCRvpapwYOuR+8PzVr7tdPzFHfVCj62qUIFlR90='
WHERE
key_id = 'c7ea6c0817d2c75c979b4f2f3621c0b8a15db22b479d1a80cd1db5b8ecfd374e'
AND (
token = '4AX7iCRvpapwYOuR+8PzVr7tdPzFHfVCj62qUIFlR90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)