UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1NNr2wiae4KSh9AwJbt3UItWjUziwFoZ0bP9kE5Nck4='
WHERE
key_id = '4ada07cc9a271f1742495614a26b7ac670558edf86ad2654462d27a82ca24f9f'
AND (
token = '1NNr2wiae4KSh9AwJbt3UItWjUziwFoZ0bP9kE5Nck4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)