UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PTheLji6IE0fIxO56dPPmXaXnvLzU9yUa6fi+aPSFIY='
WHERE
key_id = 'e201c4ff14e0e22922223e4353c672da0d963406ea72cdcd2915a26ccb2cf39d'
AND (
token = 'PTheLji6IE0fIxO56dPPmXaXnvLzU9yUa6fi+aPSFIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)